declare @name varchar(50), @sqlstr varchar(1000) declare cur cursor for select srvname from master..sysservers where srvname like 'lnk%' open cur fetch next from cur into @name while @@fetch_status = 0 begin set @sqlstr = 'exec ' + @name + '.master.dbo.sp_dboption ''admin'',''select into/bulkcopy'',''true''' exec (@sqlstr) fetch next from cur into @name end deallocate cur